When you insert decimal data into a Netezza field and the data's decimal places exceed the number of decimal places that are available in the Netezza field, the following error is returned:

ERROR: CLI execute error: ERROR:  External Table : count of bad input rows reached maxerrors limit, see nzlog file 

For example, the error will occur if you try to insert 12.1234 into a field that is defined as NUMERIC(10,2),

You will also see an error similar to the following in the nzlog file,:

1: 954582(53) [9, NUMERIC(13,2)] digits after decimal point exceed column's scale, "7.551973625146"[9]

This behavior might also occur if you do not specify the option BULKLOAD=YES. In this case, the following error is returned:

ERROR: During insert: Unexpected protocol character/message

Currently, there is no solution or workaround.

Operating System and Release Information